﻿using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

namespace SaleOnlineSystem.Controls
{
    public partial class AddressFooter : System.Web.UI.UserControl
    {
        public string CompanyInfoName;
        public string CompanyInfoDescription;
        public string CompanyInfoMobile;
        public string CompanyInfoFax;
        public string CompanyInfoEmail;
   

        protected void Page_Load(object sender, EventArgs e)
        {
            if (!Page.IsPostBack)
            {
                DataTable dt = DAL.DCollector.DBCollector.Instance.StoredProcedureSelectTable("tbl_CompanyInfor",
                                                                                              "selectorderbyaddress");
                
                CompanyInfoName = dt.Rows[0]["CompanyInfor_Name"].ToString();
                CompanyInfoDescription = dt.Rows[0]["CompanyInfor_Description"].ToString();
                CompanyInfoMobile = dt.Rows[0]["CompanyInfor_Mobile"].ToString();
                CompanyInfoFax = dt.Rows[0]["CompanyInfor_Fax"].ToString();
                CompanyInfoEmail = dt.Rows[0]["CompanyInfor_Email"].ToString();
            }
        }
    }
}